Printing an Inventory Transactions Inquiry

Once you have entered all of the required information needed to generate an Inventory Transaction Inquiry, command options will appear allowing you to print or choose from a set of other print options.

The following information fields are displayed:

• Grp – The item group
• Item Name – The name of the item and the type of inventory transactions associated with the item. Inventory transaction types are:
  • Sale – Sales order
  • Credit – Credit order
  • Inventory adjustments – The cost adjustment type will be displayed in this field
  • Adjustment – Weight only adjustment, no value adjustment
  • Transfers in
  • Transfers out
  • Hold Purchase Order – Hold Purchase Orders are purchases entered through Purchase Orders and received through Receiving Purchase Orders, but not yet completed, and therefore, still on hold.
  • Hold Purchasing – Hold Purchasing indicates the product was received and completed on inventory hold.
  • Purchase – Purchase order
  • WO (work order) Raw Material
  • WO Dry Good
  • WO Finished Good
• Vendor/Cust – The vendor from whom this item was purchased or the customer to whom this item was sold. A blank field or '//////' indicates that the vendor identity has been lost, due to the combination of multiple lots from multiple vendors. 
• Ref # – The reference number of the inventory transaction
• Cost/Price – The total unit cost of the transaction or the per unit price at which this item was sold. Inventory adjustments display as the total net change of the valuation of the item.
• Un – The invoicing unit of measure. This is the unit of measure in which the Cost/Price is stated.
• Quantity – The total quantity of the inventory transaction. Sale, Transfer Out, WO Raw Material, and WO Dry Good display as negative quantities, as all of these transactions subtract from inventory. Credit added back to inventory, Purchase, Transfer In, and WO Finished Goods, display as positive quantities, as all of these transactions add into inventory. Inventory adjustments and weight adjustments may be positive or negative.

Note: The current on hand amount (On Hand Now) will always be listed on the first line of the display for each item.

• Un – The stocking unit of measure. This is the unit of measure in which the quantity is stated.
• Date – The date on which this transaction occurred.
• Inventory On (beginning date, DD/MM/YY) – The calculated starting inventory based on the current on-hand balance plus or minus the transactions listed.

For more information on the Inventory Transactions Inquiry see Inventory Transactions Inquiry.

Security Required : Inventory - Inventory Inquiry